package com.yhy.produce.model;

import cn.afterturn.easypoi.excel.annotation.Excel;
import com.alibaba.excel.annotation.ExcelIgnore;
import com.alibaba.excel.annotation.ExcelProperty;
import com.alibaba.excel.annotation.write.style.HeadStyle;
import lombok.Data;

@Data
@HeadStyle(fillBackgroundColor = 55) // IndexedColors.GREY_40_PERCENT
public class ExcelModel {

    @Excel(name = "ID", width = 10)
    @ExcelProperty(value = "ID")
    private Integer id;

    @Excel(name = "姓名", width = 20)
    @ExcelProperty(value = "姓名")
    private String name;

    @Excel(name = "性别", replace = {"男_1", "女_2"}, width = 10)
    @ExcelProperty(value = "性别")
    private Integer age;

    @Excel(name = "地址", width = 50)
    @ExcelProperty(value = "地址")
    private String address;

    @ExcelIgnore
    private String password;

}
